SmartSolve Data Model Structure

The SmartSolve Data Model Structure consists of the following:

Tables
Columns (name, data types, and length)
Indexes
Relationships/Constraints
Dependencies
Scripts to Recreate Tables
Views
Columns
Dependencies
Scripts to Recreate Views
Naming Standards
Tables: tbl_name where tbl represents the letter table code and name, such as ACT_ACTOR or SS_AUDIT
Column Names
ACT_LAST_NAME
ACR_ACT_ID (foreign key in ACR_ACTOR_ROLE table)
AUDITEE_CODE
Views
Prefixed with “V_”, such as V_ACTOR or V_SS_AUDIT
Header views (VH_)